SGI Freeware 2002 November

home *** CD-ROM | disk | FTP | other *** search

/ SGI Freeware 2002 November / SGI Freeware 2002 November - Disc 3.iso / dist / fw_mysql.idb / usr / freeware / catman / u_man / cat1 / mysqld.Z / mysqld

Wrap

Text File | 2002-10-07 | 14.5 KB | 298 lines

MYSQLD(1) MYSQLD(1) NNAAMMEE mmyyssqqlldd - Starts the MySQL server demon UUSSAAGGEE mysqld [OPTIONS] SSYYNNOOPPSSIISS mmyyssqqlldd [----aannssii] [--bb|----bbaasseeddiirr==_p_a_t_h] [----bbiigg--ttaabblleess] [----bbiinndd--aaddddrreessss==IIPP] [----cchhaarraacctteerr--sseettss--ddiirr==_p_a_t_h] [----cchhrroooott==_p_a_t_h] [--hh|----ddaattaaddiirr==_p_a_t_h] [----ddeeffaauulltt--cchhaarraacc tteerr--sseett==_c_h_a_r_s_e_t] [----ddeeffaauulltt--ttaabbllee--ttyyppee==_t_y_p_e_] [----ddeellaayy--kkeeyy--wwrriittee--ffoorr--aallll--ttaabblleess] [----eennaabbllee--lloocckkiinngg] [--TT|----eexxiitt--iinnffoo]] [----fflluusshh] [--??|----hheellpp] [----iinniitt--ffiillee==ffiillee] [--LL|----llaanngguuaaggee==......] [--ll|----lloogg[[==ffiillee]]] [----lloogg--iissaamm[[==ffiillee]]] [----lloogg--ssllooww--qquueerriieess_[_=_f_i_l_e_]] [----lloogg--uuppddaattee_[_=_f_i_l_e_]] [----lloogg--lloonngg--ffoorrmmaatt] [----llooww--pprriioorriittyy--uuppddaatteess] [----mmeemmlloocckk] [ ----mmyyiissaamm--rreeccoovveerr [[==ooppttiioonn[[,,ooppttiioonn......]]]]]] wwhheerree ooppttiioonn iiss oonnee ooff DDEEFFAAUULLTT,, BBAACCKKUUPP,, FFOORRCCEE oorr QQUUIICCKK..] [----ppiidd--ffiillee==_p_a_t_h] [--PP|----ppoorrtt==......] [--oo|----oolldd--pprroottooccooll] [----oonnee--tthhrreeaadd] [--OO|----sseett--vvaarriiaabblleevar=_o_p_t_i_o_n]] [--SSgg|----sskkiipp--ggrraanntt--ttaabblleess] [----ssaaffee--mmooddee] [----sseeccuurree] [----sskkiipp--ccoonnccuurrrreenntt--iinnsseerrtt] [----sskkiipp--ddeellaayy--kkeeyy--wwrriittee] [----sskkiipp--lloocckkiinngg] [----sskkiipp--nnaammee--rreessoollvvee] [----sskkiipp--nneettwwoorrkkiinngg] [----sskkiipp--nneeww] [----sskkiipp--hhoosstt--ccaacchhee] [----sskkiipp--sshhooww--ddaattaabbaassee] [----sskkiipp--tthhrreeaadd--pprriioorriittyy] [----ssoocckkeett==ppaatthh] [--tt|----ttmmppddiirr==_p_a_t_h_] [--uu|----uusseerr==_u_s_e_r___n_a_m_e] [--VV|----vveerrssiioonn] DDEESSCCRRIIPPTTIIOONN ----aannssii Use ANSI SQL syntax instead of MySQL syntax. See section 5.2 Running MySQL in ANSI Mode. --bb|----bbaasseeddiirr==_p_a_t_h Path to installation directory. All paths are usu ally resolved relative to this. ----bbiigg--ttaabblleess Allow big result sets by saving all temporary sets on file. It solves most 'table full' errors, but also slows down the queries where in-memory tables would suffice. Since Version 3.23.2, MySQL is able to solve it automaticaly by using memory for small temporary tables and switching to disk tables where necessary. ----bbiinndd--aaddddrreessss==_I_P IP address to bind to. ----cchhaarraacctteerr--sseettss--ddiirr==_p_a_t_h Directory where character sets are. See section 10.1.1 The Character Set Used for Data and Sorting. ----cchhrroooott==_p_a_t_h Chroot mysqld daemon during startup. Recommended security measure. It will somewhat limit LOAD DATA INFILE and SELECT ... INTO OUTFILE though. --hh|----ddaattaaddiirr==_p_a_t_h Path to the database root. ----ddeeffaauulltt--cchhaarraacctteerr--sseett==_c_h_a_r_s_e_t Set the default character set. See section 10.1.1 The Character Set Used for Data and Sorting. ----ddeeffaauulltt--ttaabbllee--ttyyppee==_t_y_p_e Set the default table type for tables. See section 8 MySQL Table Types. ----ddeellaayy--kkeeyy--wwrriittee--ffoorr--aallll--ttaabblleess Don't flush key buffers between writes for any MyISAM table. See Mysql Manual section 12.2.3 Tun ing Server Parameters. ----eennaabbllee--lloocckkiinngg Enable system locking. --TT|----eexxiitt--iinnffoo Print some debug info at exit. ----fflluusshh Flush all changes to disk after each SQL command. Normally MySQL only does a write of all changes to disk after each SQL command and lets the operating system handle the syncing to disk. See section 20.2 What to Do if MySQL Keeps Crashing. --??|----hheellpp Display short help and exit. ----iinniitt--ffiillee==_f_i_l_e Read SQL commands from this file at startup. --LL|----llaanngguuaaggee==...... Client error messages in given language. May be given as a full path. See Mysql Manual section 10.1 What Languages Are Supported by MySQL?. --ll|----lloogg_[_=_f_i_l_e_] Log connections and queries to file. ----lloogg--iissaamm_[_=_f_i_l_e_] Log all ISAM/MyISAM changes to file (only used when debugging ISAM/MyISAM). ----lloogg--ssllooww--qquueerriieess_[_=_f_i_l_e_] Log all queries that have taken more than long_query_time seconds to execute to file. See Mysql Manual section 21.5 The Slow Query Log. ----lloogg--uuppddaattee_[_=_f_i_l_e_] Log updates to file.# where # is a unique number if not given. See Mysql Manual section 21.3 The Update Log. ----lloogg--lloonngg--ffoorrmmaatt Log some extra information to update log. If you are using ----lloogg--ssllooww--qquueerriieess then queries that are not using indexes are logged to the slow query log. ----llooww--pprriioorriittyy--uuppddaatteess Table-modifying operations (INSERT/DELETE/UPDATE) will have lower priority than selects. It can also be done via {INSERT | REPLACE | UPDATE | DELETE} LOW_PRIORITY ... to lower the priority of only one query, or by SET OPTION SQL_LOW_PRIORITY_UPDATES=1 to change the priority in one thread. See Mysql Manual section 12.2.9 Table Locking Issues. ----mmeemmlloocckk Lock the mysqld process in memory. This works only if your system supports the mlockall() system call. This may help if you have a problem where the oper ating system is causing mysqld to swap on disk. ----mmyyiissaamm--rreeccoovveerr [[==ooppttiioonn[[,,ooppttiioonn......]]]]]] wwhheerree ooppttiioonn iiss oonnee ooff DDEEFFAAUULLTT,, BBAACCKKUUPP,, FFOORRCCEE oorr QQUUIICCKK.. If this option is used, mysqld will on open check if the table is marked as crashed or if if the table wasn't closed properly (The last option only works if you are running with --skip-locking). If this is the case mysqld will run check on the table. If the table was corrupted, mysqld will attempt to repair it. The following options affects how the repair works. DDEEFFAAUULLTT The same as not giv ing any option to --myisam-recover. BBAACCKKUUPP If the data table was changed during recover, save a backup of the `table_name.MYD' data file as `table_name-datetime.BAK'. FFOORRCCEE Run recover even if we will loose more than one row from the .MYD file. QQUUIICCKK Don't check the rows in the table if there isn't any delete blocks. Before a table is automaticly repaired, mysqld will add a note about this in the error log. If you want to be able to recover from most things without user intervention, you should use the options BACKUP,FORCE. This will force a repair of a table even if some rows would be deleted, but it will keep the old data file as a backup so that you can later examine what happened. ----ppiidd--ffiillee==_p_a_t_h Path to pid file used by safe_mysqld. --PP|----ppoorrtt==...... Port number to listen for TCP/IP connections. --oo|----oolldd--pprroottooccooll Use the 3.20 protocol for compatibility with some very old clients. See Mysql Manual section 4.17.3 Upgrading from Version 3.20 to Version 3.21. ----oonnee--tthhrreeaadd Only use one thread (for debugging under Linux). See Mysql Manual section H.1 Debugging a MySQL server. --OO| ----sseett--vvaarriiaabbllee vvaarr==_o_p_t_i_o_n Give a variable a value. --help lists variables. You can find a full description for all variables in the SHOW VARIABLES section in this manual. See Mysql Manual section 7.28.4 SHOW VARIABLES. The tuning server parameters section includes informa tion of how to optimize these. See Mysql Manual section 12.2.3 Tuning Server Parameters. --SSgg|----sskkiipp--ggrraanntt--ttaabblleess This option causes the server not to use the privi lege system at all. This gives everyone full access to all databases! (You can tell a running server to start using the grant tables again by executing mysqladmin flush-privileges or mysqladmin reload.) ----ssaaffee--mmooddee Skip some optimize stages. Implies ----sskkiipp--ddeellaayy--kkeeyy--wwrriittee.. ----sseeccuurree IP numbers returned by the gethostbyname() system call are checked to make sure they resolve back to the original hostname. This makes it harder for someone on the outside to get access by pretending to be another host. This option also adds some san ity checks of hostnames. The option is turned off by default in MySQL Version 3.21 because sometimes it takes a long time to perform backward resolu tions. MySQL Version 3.22 caches hostnames (unless --skip-host-cache is used) and has this option enabled by default. ----sskkiipp--ccoonnccuurrrreenntt--iinnsseerrtt Turn off the ability to select and insert at the same time on MyISAM tables. (This is only to be used if you think you have found a bug in this fea ture). ----sskkiipp--ddeellaayy--kkeeyy--wwrriittee Ignore the delay_key_write option for all tables. See Mysql Manual section 12.2.3 Tuning Server Parameters. ----sskkiipp--lloocckkiinngg Don't use system locking. To use isamchk or myisam chk you must shut down the server. See Mysql Manual section 1.6 How Stable Is MySQL?. Note that in MySQL Version 3.23 you can use REPAIR and CHECK to repair/check MyISAM tables. ----sskkiipp--nnaammee--rreessoollvvee Hostnames are not resolved. All Host column values in the grant tables must be IP numbers or local host. ----sskkiipp--nneettwwoorrkkiinngg Don't listen for TCP/IP connections at all. All interaction with mysqld must be made via Unix sock ets. This option is highly recommended for systems where only local requests are allowed. However, this option is unsuitable for systems that use MIT-pthreads, because the MIT-pthreads package doesn't support Unix sockets. ----sskkiipp--nneeww Don't use new, possible wrong routines. Implies ----sskkiipp--ddeellaayy--kkeeyy--wwrriittee ----sskkiipp--hhoosstt--ccaacchhee Never use host name cache for faster name-ip reso lution, but query DNS server on every connect instead. ----sskkiipp--sshhooww--ddaattaabbaassee Don't allow 'SHOW DATABASE' commands, unless the user has process privilege. ----sskkiipp--tthhrreeaadd--pprriioorriittyy Disable using thread priorities for faster response time. ----ssoocckkeett==_p_a_t_h Socket file to use for local connections instead of default /tmp/mysql.sock. --tt|----ttmmppddiirr==_p_a_t_h Path for temporary files. It may be useful if your default /tmp directory resides on a partition too small to hold temporary tables. --uu|----uusseerr==_u_s_e_r___n_a_m_e Run mysqld daemon as user user_name. This option is mandatory when starting mysqld as root. --VV|----vveerrssiioonn Output version information and exit. NNOOTTEE SSEEEE AALLSSOO isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror (1), replace (1), safe_mysqld (1), which1 (1), zap (1), AAUUTTHHOORR Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme dia.com) 19 December 2000 MYSQLD(1)